<?php

include_once "lib/config.php";

include_once "header.php";



if(!isset($_POST['entertainment_id']) || $_POST['entertainment_id']==0)

{

    redirect("entertainments.php");

}



if(isset($_SESSION['msg_success']) && $_SESSION['msg_success']!="")

{

	$msg_success=$_SESSION['msg_success'];

	unset($_SESSION['msg_success']);

}



if(isset($_SESSION['msg_error']) && $_SESSION['msg_error']!="")

{

	$msg_error=$_SESSION['msg_error'];

	unset($_SESSION['msg_error']);

}





if(!isset($_POST['order_by']))

{

	$_POST['order_by']="desc";

}



if(!isset($_POST['type_title']))

{

	$_POST['type_title']="rate_date";

}



if(!isset($_POST['pid']))	// code starts for implementing pagination 

{

	$_POST['pid']=1;

}



$selectquery="select af_entertainment_ratings.*,Full_Name,Email_ID,title from af_entertainment_ratings,af_users,af_entertainments where af_users.User_ID=af_entertainment_ratings.user_id and af_entertainments.id=af_entertainment_ratings.entertainment_id and  af_entertainment_ratings.entertainment_id=:entertainmentid";

$conditionarr=array(":entertainmentid"=>$_POST['entertainment_id']);



if(isset($_POST['searchText']) && $_POST['searchText']!="" && isset($_POST['filterby']) && $_POST['filterby']!="")

{

    $selectquery.=" and ".$_POST['filterby']." like :".$_POST['filterby'];

	$conditionarr[":".$_POST['filterby']]= "%".$_POST['searchText']."%";

}



$totalrecords=DB::fetch_num_of_rows(DB::query($selectquery,$conditionarr));



$selectquery.=" order by ".$_POST['type_title']." ".$_POST['order_by']." limit ".(($_POST['pid']-1)*PAGELIMIT).", ".PAGELIMIT;



$entertainmentinfo=DB::fetch_array(DB::query($selectquery,$conditionarr));



include_once "lib/paginate_class.php";



$paging_obj=new Paginate();



$pagingdiv=$paging_obj->getnewpager($_POST['pid'],$totalrecords);





?>

        

		<div class="container_12">

        

            <div class="bottom-spacing">

                	<div class="grid_12">

        		    <fieldset>

        		    	

        		        <input class="submit-gray" type="button" value="Back" onclick="window.location='entertainments.php'" />

        		    </fieldset>

        		    </div>

                    <br/>

                    <br/>

                    <form name="mainform" method="post">

	                    <!-- Table records filtering -->

	                    Filter By: 

	                    <select class="input-short" style="width:200px;" name="filterby" id="filterby">

	                    	<option value="" selected="selected">Select filter</option>

	                        <option value="Email_ID"  <?php if(isset($_POST['filterby']) && $_POST['filterby']=="Email_ID"){ echo "selected"; } ?> >Email ID</option>

                            <option value="title"  <?php if(isset($_POST['filterby']) && $_POST['filterby']=="title"){ echo "selected"; } ?> >Entertainment Link Title</option>

                            <option value="rating"  <?php if(isset($_POST['filterby']) && $_POST['filterby']=="rating"){ echo "selected"; } ?> >Rating</option>

	                    </select>

	                    &nbsp;&nbsp;&nbsp;&nbsp;

	                    <input type="text" class="input-short" style="width:300px;" name="searchText" id="searchText" value="<?php if(isset($_POST['searchText'])){ echo $_POST['searchText']; } ?>">

	                    &nbsp;&nbsp;

	                    <input type="button" class="submit-green" value="Search" onclick="return getempfilterresults();"> &nbsp;&nbsp;<input type="button" class="submit-green" value="Show All" onclick="document.getElementById('filterby').value='';document.getElementById('searchText').value='';document.mainform.submit();">

	                    <input type="hidden" name="opt_status" id="opt_status">

                        <input type="hidden" id="entertainment_id" name="entertainment_id" value="<?php if(isset($_POST['entertainment_id'])){ echo $_POST['entertainment_id']; } ?>" />

						<input type="hidden" name="pid" id="pid" value="<?php if(isset($_POST['pid']))echo $_POST['pid']; ?>">

						<input type="hidden" name="type_title" id="type_title" value="<?php if(isset($_POST['type_title']))echo $_POST['type_title']; ?>">

						<input type="hidden" name="order_by" id="order_by" value="<?php if(isset($_POST['order_by']))echo $_POST['order_by']; ?>">

						

					</form>

                	<br>

            </div>

            

            

                <!-- Example table -->

                <div class="module" style="width:100% !important;">

                	<h2><span>Apps/Games Ratings List</span></h2>

                    

                    <div class="module-table-body">

                    	

                        <table id="myTable" >

                        	<thead>

                                <tr>

                                    <th style="width:10%">Sr.No.</th>

                                    <th style="width:15%"><a href="javascript:void(0)" onclick="return change_order('title','<?php echo $_POST['order_by'] ?>')" >Entertainment Link Title</a></th>

                                    <th style="width:15%"><a href="javascript:void(0)" onclick="return change_order('rating','<?php echo $_POST['order_by'] ?>')" >Rating</a></th>

                                    <th style="width:12%"><a href="javascript:void(0)" onclick="return change_order('Email_ID','<?php echo $_POST['order_by'] ?>')" >Email ID</a></th>

                                    <th style="width:12%"><a href="javascript:void(0)" onclick="return change_order('Full_Name','<?php echo $_POST['order_by'] ?>')" >User Full Name</a></th>

                                    <th style="width:12%"><a href="javascript:void(0)" onclick="return change_order('rate_date','<?php echo $_POST['order_by'] ?>')" >Rating Date</a></th>

                                    

                                </tr>

                            </thead>

                            <tbody>

                            <?php

                            if(count($entertainmentinfo)>0)

                            {

                            	$count=0;

                            	for($i=0;$i<count($entertainmentinfo);$i++)

                            	{

                            		$count++;

                            ?>

							    <tr <?php if($count%2==0)echo "class='odd'"; else echo "class='even'"; ?>>

                                    <td class="align-center"><?php echo ($i+1);  ?></td>

                                    <td><?php echo $entertainmentinfo[$i]['title']; ?></td>

                                    <td><?php echo trim($entertainmentinfo[$i]['rating']); ?></td>

                                    <td><?php echo $entertainmentinfo[$i]['Email_ID']; ?></td>

                                    <td><?php echo $entertainmentinfo[$i]['Full_Name']; ?></td>

                                    <td><?php echo date("d/m/Y",trim($entertainmentinfo[$i]['rate_date'])); ?></td>

                                </tr>

                            <?php

                            	}

                            }

                            else

                            {

								?>

								<tr>

									<td colspan="6"><span class="redspan">There is no record found!!!</span></td>

								</tr>

								<?php	

							}

                            ?>

                            </tbody>

                        </table>

                        <br>

                        <?php echo $pagingdiv; ?>

                        

                        <div style="clear: both"></div>

                     </div> <!-- End .module-table-body -->

                </div> <!-- End .module -->

                

                

            

            <div style="clear:both;"></div>

            

            

        </div> <!-- End .container_12 -->

		

<?php include_once("footer.php"); ?>   

<?php

if(isset($msg_success) && $msg_success!="")

{

	$notymessage=$msg_success;

	$msgtype="success";

}

else if(isset($msg_error) && $msg_error!="")

{

	$msgtype="error";

	$notymessage=$msg_error;

}

else

{

	$msgtype="";

}

if($msgtype!="")

{

?>        

<script language="javascript">

	$(document).ready(function(){

		

		var options = $.parseJSON('{"text":"<?php echo $notymessage; ?>","layout":"top","type":"<?php echo $msgtype; ?>"}');

		noty(options);

		

	});

</script>  

<?php

}

?>